﻿CREATE TABLE [dbo].[AmixSetup] (
    [PrimaryKey]         SMALLINT     CONSTRAINT [DF_AmixSetup_PrimaryKey] DEFAULT ((0)) NOT NULL,
    [LunaCurenta]        SMALLINT     CONSTRAINT [DF_AmixSetup_LunaCurenta] DEFAULT ((0)) NOT NULL,
    [AnulCurent]         SMALLINT     CONSTRAINT [DF_AmixSetup_AnulCurent] DEFAULT ((0)) NOT NULL,
    [CodUnitate]         SMALLINT     CONSTRAINT [DF_AmixSetup_CodUnitate] DEFAULT ((0)) NOT NULL,
    [IDSerieInventar]    VARCHAR (20) NULL,
    [AfiseazaAmortizare] BIT          CONSTRAINT [DF_AmixSetup_AfiseazaAmortizare] DEFAULT ((1)) NOT NULL,
    [IstoricAmortizare]  BIT          CONSTRAINT [DF_AmixSetup_IstoricAmortizare] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_AmixSetup] PRIMARY KEY CLUSTERED ([PrimaryKey] ASC, [CodUnitate] ASC),
    CONSTRAINT [FK_AmixSetup_Unitati] FOREIGN KEY ([CodUnitate]) REFERENCES [dbo].[Unitati] ([CodUnitate])
);

